End-of-Year Guidelines: 2021

Last updated on February 26, 2024 09:37 AM

Important Deadlines

Form Due to recipient by Mail to IRS by E-file with IRS by
1099-NEC 1/31/2022 1/31/2022 1/31/2022
1099-MISC 1/31/2022 2/28/2022 3/31/2022
W-2 1/31/2022 1/31/2022 1/31/2022
1095-C 3/2/2022 2/28/2022 3/31/2022

Accounts Payable

1099s

Before you create 1099s for 2021, upgrade to ActivityHD 8.17-3 or higher.

1099 Frequently Asked Questions

ClosedWhich form design and which envelopes should I use for 1099 printing?

ClosedWhich report do I use to proof/reconcile 1099s?

ClosedCan you guide me through the 1099 generation and filing process?

ClosedExplain the 1099 types which ActivityHD supports.

ClosedTell me about APCodes.

ClosedHow does ActivityHD know which box to print amounts in for 1099s?

Payroll

W-2s

To file electronically from ActivityHD, use the "USA 2021 EFW2" export control. After you've upgraded to version 8.17-3 or later, you can import the export control from the distribution folder path "\Extras\Payroll\Export Controls\USA 2021 EFW2.XML". Contact AccountingWare Support if you need assistance.

According to Social Security Administration Publication 42-007, EFW2 Tax Year 2021 "Specifications for Filing Forms W-2 Electronically (EFW2)", no field changes were required for the 2021 EFW2 file. However, ActivityHD has changed the way the "Location Address" field is set. Until this year, the "Location Address" value was left blank (positions 66-87). Going forward, "Location Address" is set to AddressLine2 from the employee's government location. The "Location Address" is typically used for information such as attention, suite, room number, etc.

Before You W-2

Before you begin W-2 processing, it's good to verify that the following information is accurate/up-to-date:

  • Export employers
  • Export submitters
  • Company address
  • Employer tax ID on the Payroll USA tax entity (and state tax IDs if applicable)
  • Payroll groups and the PRCodes assigned to them. In particular, filter the Segment Items or PRCodes HD view and apply the "? Has Group" filter to verify the PRCodes assigned to the following groups:
    • Compensation (Pay PRCodes)
    • IncomeTax (Tax PRCodes)
    • PreIncomeTax, PreMedicare, PreSocialSecurity (Deduction PRCodes)
    • 401k, Roth401k, 403b, 457b, etc. (Deduction PRCodes)
    • ThirdPartySickPay (Pay PRCodes)
    • Employer-sponsored health plans (Deduction PRCodes)
    • COVID sick pay (Pay PRCodes)

    Note

    If segment items are missing from any groups and you add them, be sure to review prior calculated taxes and create any necessary correcting checks, make additional payments to the IRS, and file amended 941 forms. Consult AccountingWare Support for assistance.

  • Taxable wages. Import and use the Taxable Wages export control (found in your "Extras" distribution folder). Use "Verify" filters to locate problem checks. (You can copy existing "Proof" filters on the Checks folder and change the value of the Merged flag from "0" to "1" in the conditions.) Look for these types of problems:
    • Federal taxes (income tax, Medicare, social security). Make correcting checks to fix discrepancies. Call AccountingWare Support for assistance with correcting checks.
    • State taxes (income tax, miscellaneous state taxes). Make correcting checks to fix discrepancies.

Noteworthy

Effective 1/1/2016, the Social Security Administration will return electronic and paper wage reports which contain a W-2 with any of the following:

  • Medicare Wages and Tips less than the sum of Social Security Wages and Social Security Tips.
  • Social Security Tax greater than zero, but Social Security Wages and Social Security Tips equal to zero.
  • Medicare Tax greater than zero, but Medicare Wages and Tips equal to zero.

The Generate W-2s wizard validates for these conditions.

If you furnish W-2 forms to employees electronically, you must meet a couple of requirements:

  • You must obtain employee consent and meet certain disclosure requirements.

  • You must provide employees with the required EIC notice. This notice is typically printed on the back of blank W-2 stock.

Generate and Print W-2s

Create an export totals file

W-2 Frequently Asked Questions

ClosedHow do I generate W-2 forms?

ClosedHow do I file electronically using the export control USA 2021 EFW2?

ClosedWhy don't the amounts on the W-2 match actual wages?

ClosedHow do I replace the W-2 records currently attached in Self-Serve?

ClosedHow do I change the company address that prints on W-2s?

ClosedWhich report design and which envelopes should I use to print W-2s?

ClosedCan W-2s be emailed to employees?

ClosedHow do I get the 2021 EFW2 file?

ClosedWhat is AccuWage?

Preparing for 2022

Form 940 Reporting

Generate and print Form 940 returns

Affordable Care Act (ACA) Reporting: 1095-Cs

Best practices for processing 1095-C forms:

Payroll Tax Function Updates

Because income tax functions are built into ActivityHD Payroll, you must upgrade to version 8.17-3 or later for the 2022 tax year. After this upgrade, AccountingWare will add the tax table update. Contact AccountingWare for the 2022 upgrade.

Parameter Updates

Add new effective dates and values for the parameters indicated by a checkmark. Other parameters did not change and are included for reference only. To edit parameters, go to Payroll/Human Resources > Setup > Segment Items > Parameters. You can filter by "Tax" for most; for others, filter by "Deduction".

Tip

Although it is not necessary to add an entry for parameters which have not changed since the prior year, adding a new entry for each parameter will help you know that the parameter has been reviewed for the current tax year.

Parameter Description Value Effective Date Change?
Type:Ded:MaxHSAUnder55 HSA Maximum for under 55 Individual: $3650 01/01/2022
    Family: $7300 01/01/2022
Type:Ded:MaxHSAGTE55 HSA Maximum for 55 and older Individual: $4650 01/01/2022
    Family: $8300 01/01/2022
Type:Tax:SocSecMax Social Security Maximum $147,000 01/01/2022
Type:Tax:SocSecEEPercent Social Security Employee Percent 6.20% 01/01/2011  
Type:Tax:SocSecERPercent Social Security Employer Percent 6.20% 01/01/2011  
Type:Tax:MedEEPercent Medicare Employee Percent 1.45% 01/01/2010  
Type:Tax:MedERPercent Medicare Employer Percent 1.45% 01/01/2010  
Type:Tax:MedEEAddPercent Additional Medicare Employee Percent 0.90% 01/01/2013  
Type:Tax:MedEEThreshold Medicare Employee Wages Threshold $200,000 01/01/2013  
<user defined> Standard mileage rate 58.5 cents/mile; 62.5 cents/mile eff. 7/1/2022 01/01/2022
<user defined> 401(k) and 457(b) limitation $20,500 01/01/2022

Tip

AccountingWare suggests that when you enter this year's Social Security Maximum, you also add a row for next year with an effective date of January 1 of next year. Leave the value blank. If you attempt to produce checks with next year's date on them before the maximum has been updated, ActivityHD will not be able to calculate Social Security on the checks until the maximum is entered.

FUTA/SUTA

Closed Expand this link to see the SUTA wage base values by state for 2021 and 2022.

State 2021 2022
Alabama $8,000  
Alaska $43,600 $45,200
Arizona $7,000  
Arkansas $10,000 $10,000
California $7,000 $7,000
Colorado $13,600 $17,000
Connecticut $15,000 $15,000
Delaware $16,500 $14,500
District of Columbia $9,000  
Florida $7,000  
Georgia $9,500  
Hawaii $47,400 $51,600
Idaho $43,000 $46,500
Illinois $12,960 $12,960
Indiana $9,500 $9,500
Iowa $32,400 $34,800
Kansas $14,000 $14,000
Kentucky $10,800 $11,100
Louisiana $7,700 $7,700
Maine $12,000  
Maryland $8,500  
Massachusetts $15,000  
Michigan $9,500 $9,500
Minnesota $35,000 $38,000
Mississippi $14,000  
Missouri $11,000 $11,000
Montana $35,300 $38,100
Nebraska $9,000 $9,000
Nevada $33,400 $36,600
New Hampshire $14,000  
New Jersey $36,200 $39,800
New Mexico $27,000 $28,700
New York $11,800 $12,000
North Carolina $26,000 $28,000
North Dakota $38,500 $38,400
Ohio $9,000 $9,000
Oklahoma $24,000 $24,800
Oregon $43,800 $47,700
Pennsylvania $10,000 $10,000
Puerto Rico $7,000  
Rhode Island $24,600 $24,600
South Carolina $14,000 $14,000
South Dakota $15,000 $15,000
Tennessee $7,000  
Texas $9,000  
Utah $38,900 $41,600
Vermont $14,100 $15,500
Virgin Islands $32,500 $30,800
Virginia $8,000  
Washington $56,500 $62,500
West Virginia $12,000  
Wisconsin $14,000 $14,000
Wyoming $27,300 $27,700

Bold formatting indicates a wage base increase for 2021.

Bold italic formatting indicates a wage base decrease for 2021.

Deduction Parameters

To update employee automatics with the annual census, do the following:

Tip

AccountingWare Support is ready and willing to help you perform these updates!

  1. Use mass-change to expire your existing automatics.
  2. Use the "Import Employee Automatics" workbook to import automatics for the new year.
  3. Use the "Import Employee Parameters" workbook to import life insurance options.

Fixed Assets

General Ledger

  • Update your GL calendars to allow posting for 2022. Packages will not perform as expected if accounting periods for 2022 are not assigned appropriately.
  • Create a new year and periods for payroll calendars. Use the period wizard and, where needed, update the number of workdays.

Miscellaneous tasks

  • To ensure that reports and processes run smoothly in the new year, be sure to update date references in your report and action profiles (aka "saved answers") and in Crystal Report designs. Also update any other settings which may have changed since 2021.

Resources

×

1099 Detail Report

Purpose

For each vendor in your selection, the 1099 Detail Report shows 1099 amounts by return type during a specified date range.

Content

For each vendor on the report, the report shows:

  • vendor name
  • vendor federal ID number
  • 1099 income type
  • 1099 total for transactions in the date range.

In addition, you can include one or more of the following:

  • payment detail (payment date, reference, merge number; invoice date, invoice number, merge number; invoice payment APCode, gross payment, amount)
  • reporting location.

The following total appears on the report:

  • record count.

Preinstalled saved answers

For your convenience, ActivityHD includes four preinstalled saved answers for common reporting scenarios.

Print the report

  1. In the Navigation pane, highlight the Accounts Payable > Vendors folder.
  2. Start the report set-up wizard.
    • To report on all or a filtered subset of vendors:
      1. Right-click the Vendors folder and select Select and Report > 1099 Detail Report from the shortcut menu.
      2. On the Selection tab, define any filters to apply to the data.

    • To report on specifically selected vendors:
      1. In the HD view, select the vendors to include on the report. You can use Ctrl and/or Shift selection to select multiple records.
      2. Click and select 1099 Detail Report from the drop-down menu.
    • To report on a particular vendor from the Vendor window:
      1. In the HD view, locate and double-click the vendor to report on. The Vendor window opens with the vendor loaded.
      2. Click and select 1099 Detail Report from the drop-down menu.
  3. Select the Detail tab.

  4. In the Payment Begin Date and Payment End Date fields, enter the range of vendor payment dates for which to include transaction information on the report.
  5. In the Return Types section, ensure that the checkbox is marked for each 1099 return type you want to include on the report. Your options are:
    • 1099-DIV Dividends and Distributions
    • 1099-INT Interest Income
    • 1099-MISC Miscellaneous Income
    • 1099-NEC Nonemployee Compensation
    • 1099-R Distributions from Pensions, ...
  6. Select the Options tab.

  7. If you only want to show vendors on the report that would be included in the 1099 creation process, mark the Apply Minimum Amount Limits checkbox.
  8. If you want to suppress transaction detail and show only 1099 totals for each vendor, mark the Totals Only checkbox. If you mark this checkbox, the remaining checkboxes on the tab are disabled; skip to step 11.
  9. If you want to limit the report to vendors who are missing required 1099 information or whose combined address fields exceed 40 characters, mark the Only Show Vendors with Validation Errors checkbox.
  10. Mark the checkbox(es) for the additional information to include:
    • Payment Detail
    • Reporting Location
  11. To include a section at the end of the report with the report settings used to produce the report, leave the Include Report Options checkbox marked. To produce the report without this information, clear the checkbox.
  12. Select the Output tab.
  13. In the Design field, look up and select the report design to use.
  14. In the toolbar, click the icon for the type of output you want:
    • - Provides access to two preview options.
      • Preview - Click the icon or click the drop-down arrow and select Preview from the drop-down menu to view the report in the Crystal Reports viewer.
      • Preview to PDF - Click the drop-down arrow next to the icon and select Preview to PDF to view the report in the PDF reader.
    • - Opens the Print dialog so that you can select and configure a printer and then print a paper copy of the report.
    • - Opens the Report Email dialog so that you can address and compose an email that the report will be attached to. For best results, ensure your email client is running before you attempt to send a report via email.
    • - Opens the Export Report dialog so that you can save the report to a file. File types include Crystal Reports (.rpt), PDF (.pdf), Microsoft Excel (.xls), Microsoft Word (.doc), rich text (.rtf), and XML (.xml).

Data extensions

The following data extension is available for the report:

  • Vendors
  • Invoices
  • Payments